﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using DTO;

namespace DAO
{
   public class DiemHKDAO
    {
       public static void delete(int hk, int lop)
       {
           String sSQL = "delete from diem_hk where id_hk = " + hk + " and id_lop = " + lop;
           DAO.KetNoi.clsConnect.executeNonQuery(sSQL);
       }

       public static void Insert(DiemHKDTO d)
       {
           String sSQL = "Insert into diem_hk(id_lop, id_hs, id_hk, tbhk1, tbhk2, tbhk,hoc_luc, hanh_kiem) values (" + d.Id_lop + ", " + d.Id_hs + ", " + d.Id_hk + ", " + d.Tbhk1 + ", " + d.Tbhk2 + ", " + d.Tbhk + ", " + d.Hoc_luc + ", " + d.Hanh_kiem + ")";
           DAO.KetNoi.clsConnect.executeNonQuery(sSQL);
       }
    }
}
